'Declaration Public Overloads Function ApplyFixedValuesFilter( _ ByVal includeBlanks As Boolean, _ ByVal displayValues As IEnumerable(Of String) _ ) As FixedValuesFilter
public FixedValuesFilter ApplyFixedValuesFilter( bool includeBlanks, IEnumerable<string> displayValues )
Exception | Description |
---|---|
System.ArgumentNullException | displayValues is null. |
System.ArgumentNullException | A value in the displayValues collection is null. |
System.ArgumentException | Multiple values from the displayValues collection are case-insensitively equal. |
System.InvalidOperationException | includeBlanks is False and displayValues has no items. At least one value must be allowed. |
System.InvalidOperationException | The WorksheetTable.IsFilterUIVisible value of the owning table is False. Filters cannot be applied when the header row or filter button is hidden. |
Note: If any text values are longer than 255 characters in length and the workbook is saved in one of the 2003 formats, the correct rows will be hidden in the saved file, but the filter may be missing from the column or reapplying the filter may hide some of the matching cells.
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2